SUPPORT / SAMPLES & SAS NOTES
Problem Note 61457: The %SEFUTREE macro fails with "Error updating table entry ... ROLLBACK issued ..." messages when you add a new node to your hierarchy results
 |  |  |  |
In SAS Energy Forecasting, when you attempt to add a new node to your hierarchy in the utility tableutil_loc_dim.sas7bdata, the %SEFUTREE macro might fail with errors such as these:
ERROR: Error updating table entry: ERROR: update or delete on table "time_series" violates foreign key constraint
"reconcile_timeseries" on table "reconcile_zone_mapping" Key (time_series_id)=(16814) is still referenced from table
"reconcile_zone_mapping".; SetPos delete return error
ERROR: ROLLBACK issued due to errors for data set SASEF.TIME_SERIES.DATA.
"reconcile_timeseries" on table "reconcile_zone_mapping" Key (time_series_id)=(16814) is still referenced from table
"reconcile_zone_mapping".; SetPos delete return error
ERROR: ROLLBACK issued due to errors for data set SASEF.TIME_SERIES.DATA.
The issue occurs when inserting the new node in the middle of the utility table, as opposed to inserting the new node at the end of the utility table.
To obtain a fix for this issue, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Energy Forecasting | Linux for x64 | 3.2_M1 | 4.1 | 9.4 TS1M4 | 9.4 TS1M5 |
| Microsoft® Windows® for x64 | 3.2_M1 | 4.1 | 9.4 TS1M4 | 9.4 TS1M5 | ||